#使用pandas读取Excel
#http://python.jobbole.com/80972/
import pandas as pd
import numpy as np 

excel_path = 'sample-salesv3.xlsx'
df = pd.read_excel(excel_path)

print(df.dtypes) #输出各列的数据类型

print(type(df))
#print(df.items) #所有数据
#print(df['date']) #date列的数据
df['date'] = pd.to_datetime(df['date']) #转换该列的格式
print(df['date'])